Creating a Query with Advanced Mode

This topic describes how to create a query using advanced mode.

To create a simple query, see Creating a Query.

Follow these steps to create a new data query with Advanced Mode.

Enable Advanced Mode and manually define query in the Query box provided.
For Example,

Note: An error message will pop-up, if wrong "Clause Name" and "Syntax" is mentioned in the box. For example,
Click Run Query. The query is generated based on the parameters you have specified, and the qualifying records appear in grid format, below. For example,